inherited fmSevkAdresSablon: TfmSevkAdresSablon
  Left = 503
  Top = 200
  Caption = 'Sevk Adres '#350'ablonu'
  ClientHeight = 418
  ClientWidth = 733
  PixelsPerInch = 96
  TextHeight = 13
  object cxGrid1: TcxGrid [0]
    Left = 0
    Top = 0
    Width = 733
    Height = 377
    Align = alClient
    TabOrder = 0
    object cxGrid1DBTableView1: TcxGridDBTableView
      NavigatorButtons.ConfirmDelete = False
      DataController.DataSource = dsSablonList
      DataController.Summary.DefaultGroupSummaryItems = <>
      DataController.Summary.FooterSummaryItems = <>
      DataController.Summary.SummaryGroups = <>
      OptionsBehavior.FocusCellOnTab = True
      OptionsBehavior.FocusFirstCellOnNewRecord = True
      OptionsBehavior.GoToNextCellOnEnter = True
      OptionsData.Appending = True
      OptionsView.GroupByBox = False
      object cxGrid1DBTableView1CARIKOD: TcxGridDBColumn
        Caption = 'Aktar'#305'm Carisi'
        DataBinding.FieldName = 'CARIKOD'
        PropertiesClassName = 'TcxLookupComboBoxProperties'
        Properties.DropDownAutoSize = True
        Properties.KeyFieldNames = 'carikod'
        Properties.ListColumns = <
          item
            FieldName = 'Firma'
          end>
        Properties.ListSource = dsCariList
        SortIndex = 0
        SortOrder = soAscending
        Width = 281
      end
      object cxGrid1DBTableView1SABLON: TcxGridDBColumn
        Caption = #350'ablon Ad'#305
        DataBinding.FieldName = 'SABLON'
        Width = 118
      end
      object cxGrid1DBTableView1ARP_CODE: TcxGridDBColumn
        Caption = 'Cari Kodu'
        DataBinding.FieldName = 'ARP_CODE'
        PropertiesClassName = 'TcxLookupComboBoxProperties'
        Properties.DropDownListStyle = lsEditList
        Properties.KeyFieldNames = 'BASLIK'
        Properties.ListColumns = <
          item
            FieldName = 'BASLIK'
          end>
        Properties.ListSource = dsExcelBaslik
        Properties.ReadOnly = True
        Visible = False
        Width = 96
      end
      object cxGrid1DBTableView1CODE1: TcxGridDBColumn
        Caption = 'Kod1'
        DataBinding.FieldName = 'CODE1'
        PropertiesClassName = 'TcxLookupComboBoxProperties'
        Properties.DropDownAutoSize = True
        Properties.DropDownListStyle = lsEditList
        Properties.KeyFieldNames = 'BASLIK'
        Properties.ListColumns = <
          item
            FieldName = 'BASLIK'
          end>
        Properties.ListSource = dsExcelBaslik
        Visible = False
        Width = 80
      end
      object cxGrid1DBTableView1CODE2: TcxGridDBColumn
        Caption = 'Kod2'
        DataBinding.FieldName = 'CODE2'
        PropertiesClassName = 'TcxLookupComboBoxProperties'
        Properties.DropDownAutoSize = True
        Properties.DropDownListStyle = lsEditList
        Properties.KeyFieldNames = 'BASLIK'
        Properties.ListColumns = <
          item
            FieldName = 'BASLIK'
          end>
        Properties.ListSource = dsExcelBaslik
        Visible = False
        Width = 80
      end
      object cxGrid1DBTableView1CODE3: TcxGridDBColumn
        Caption = 'Kod3'
        DataBinding.FieldName = 'CODE3'
        PropertiesClassName = 'TcxLookupComboBoxProperties'
        Properties.DropDownAutoSize = True
        Properties.DropDownListStyle = lsEditList
        Properties.KeyFieldNames = 'BASLIK'
        Properties.ListColumns = <
          item
            FieldName = 'BASLIK'
          end>
        Properties.ListSource = dsExcelBaslik
        Visible = False
        Width = 80
      end
      object cxGrid1DBTableView1CODE: TcxGridDBColumn
        Caption = 'Kodu'
        DataBinding.FieldName = 'CODE'
        PropertiesClassName = 'TcxLookupComboBoxProperties'
        Properties.DropDownAutoSize = True
        Properties.DropDownListStyle = lsEditList
        Properties.KeyFieldNames = 'BASLIK'
        Properties.ListColumns = <
          item
            FieldName = 'BASLIK'
          end>
        Properties.ListSource = dsExcelBaslik
        Width = 80
      end
      object cxGrid1DBTableView1DESCRIPTION: TcxGridDBColumn
        Caption = 'Sevk A'#231#305'klama'
        DataBinding.FieldName = 'DESCRIPTION'
        PropertiesClassName = 'TcxLookupComboBoxProperties'
        Properties.DropDownAutoSize = True
        Properties.DropDownListStyle = lsEditList
        Properties.KeyFieldNames = 'BASLIK'
        Properties.ListColumns = <
          item
            FieldName = 'BASLIK'
          end>
        Properties.ListSource = dsExcelBaslik
        Width = 80
      end
      object cxGrid1DBTableView1AUXIL_CODE: TcxGridDBColumn
        Caption = #214'zelkod'
        DataBinding.FieldName = 'AUXIL_CODE'
        PropertiesClassName = 'TcxLookupComboBoxProperties'
        Properties.DropDownAutoSize = True
        Properties.DropDownListStyle = lsEditList
        Properties.KeyFieldNames = 'BASLIK'
        Properties.ListColumns = <
          item
            FieldName = 'BASLIK'
          end>
        Properties.ListSource = dsExcelBaslik
        Width = 80
      end
      object cxGrid1DBTableView1ADDRESS1: TcxGridDBColumn
        Caption = 'Adres1'
        DataBinding.FieldName = 'ADDRESS1'
        PropertiesClassName = 'TcxLookupComboBoxProperties'
        Properties.DropDownAutoSize = True
        Properties.DropDownListStyle = lsEditList
        Properties.KeyFieldNames = 'BASLIK'
        Properties.ListColumns = <
          item
            FieldName = 'BASLIK'
          end>
        Properties.ListSource = dsExcelBaslik
        Width = 80
      end
      object cxGrid1DBTableView1ADDRESS2: TcxGridDBColumn
        Caption = 'Adres2'
        DataBinding.FieldName = 'ADDRESS2'
        PropertiesClassName = 'TcxLookupComboBoxProperties'
        Properties.DropDownAutoSize = True
        Properties.DropDownListStyle = lsEditList
        Properties.KeyFieldNames = 'BASLIK'
        Properties.ListColumns = <
          item
            FieldName = 'BASLIK'
          end>
        Properties.ListSource = dsExcelBaslik
        Width = 80
      end
      object cxGrid1DBTableView1TOWN: TcxGridDBColumn
        Caption = #304'l'#231'e'
        DataBinding.FieldName = 'TOWN'
        PropertiesClassName = 'TcxLookupComboBoxProperties'
        Properties.DropDownAutoSize = True
        Properties.DropDownListStyle = lsEditList
        Properties.KeyFieldNames = 'BASLIK'
        Properties.ListColumns = <
          item
            FieldName = 'BASLIK'
          end>
        Properties.ListSource = dsExcelBaslik
        Width = 80
      end
      object cxGrid1DBTableView1CITY: TcxGridDBColumn
        Caption = #304'l'
        DataBinding.FieldName = 'CITY'
        PropertiesClassName = 'TcxLookupComboBoxProperties'
        Properties.DropDownAutoSize = True
        Properties.DropDownListStyle = lsEditList
        Properties.KeyFieldNames = 'BASLIK'
        Properties.ListColumns = <
          item
            FieldName = 'BASLIK'
          end>
        Properties.ListSource = dsExcelBaslik
        Width = 80
      end
      object cxGrid1DBTableView1COUNTRY: TcxGridDBColumn
        Caption = #220'lke'
        DataBinding.FieldName = 'COUNTRY'
        PropertiesClassName = 'TcxLookupComboBoxProperties'
        Properties.DropDownAutoSize = True
        Properties.DropDownListStyle = lsEditList
        Properties.KeyFieldNames = 'BASLIK'
        Properties.ListColumns = <
          item
            FieldName = 'BASLIK'
          end>
        Properties.ListSource = dsExcelBaslik
        Width = 80
      end
      object cxGrid1DBTableView1POSTAL_CODE: TcxGridDBColumn
        Caption = 'Posta Kodu'
        DataBinding.FieldName = 'POSTAL_CODE'
        PropertiesClassName = 'TcxLookupComboBoxProperties'
        Properties.DropDownAutoSize = True
        Properties.DropDownListStyle = lsEditList
        Properties.KeyFieldNames = 'BASLIK'
        Properties.ListColumns = <
          item
            FieldName = 'BASLIK'
          end>
        Properties.ListSource = dsExcelBaslik
        Width = 80
      end
      object cxGrid1DBTableView1TELEPHONE1: TcxGridDBColumn
        Caption = 'Telefon - 1'
        DataBinding.FieldName = 'TELEPHONE1'
        PropertiesClassName = 'TcxLookupComboBoxProperties'
        Properties.DropDownAutoSize = True
        Properties.DropDownListStyle = lsEditList
        Properties.KeyFieldNames = 'BASLIK'
        Properties.ListColumns = <
          item
            FieldName = 'BASLIK'
          end>
        Properties.ListSource = dsExcelBaslik
        Width = 80
      end
      object cxGrid1DBTableView1TELEPHONE2: TcxGridDBColumn
        Caption = 'Telefon - 2'
        DataBinding.FieldName = 'TELEPHONE2'
        PropertiesClassName = 'TcxLookupComboBoxProperties'
        Properties.DropDownAutoSize = True
        Properties.DropDownListStyle = lsEditList
        Properties.KeyFieldNames = 'BASLIK'
        Properties.ListColumns = <
          item
            FieldName = 'BASLIK'
          end>
        Properties.ListSource = dsExcelBaslik
        Width = 80
      end
      object cxGrid1DBTableView1FAX: TcxGridDBColumn
        Caption = 'Fax'
        DataBinding.FieldName = 'FAX'
        PropertiesClassName = 'TcxLookupComboBoxProperties'
        Properties.DropDownAutoSize = True
        Properties.DropDownListStyle = lsEditList
        Properties.KeyFieldNames = 'BASLIK'
        Properties.ListColumns = <
          item
            FieldName = 'BASLIK'
          end>
        Properties.ListSource = dsExcelBaslik
        Width = 80
      end
      object cxGrid1DBTableView1TAX_OFFICE: TcxGridDBColumn
        Caption = 'Vergi Dairesi'
        DataBinding.FieldName = 'TAX_OFFICE'
        PropertiesClassName = 'TcxLookupComboBoxProperties'
        Properties.DropDownAutoSize = True
        Properties.DropDownListStyle = lsEditList
        Properties.KeyFieldNames = 'BASLIK'
        Properties.ListColumns = <
          item
            FieldName = 'BASLIK'
          end>
        Properties.ListSource = dsExcelBaslik
        Width = 80
      end
      object cxGrid1DBTableView1TAX_NR: TcxGridDBColumn
        Caption = 'Vergi No'
        DataBinding.FieldName = 'TAX_NR'
        PropertiesClassName = 'TcxLookupComboBoxProperties'
        Properties.DropDownAutoSize = True
        Properties.DropDownListStyle = lsEditList
        Properties.KeyFieldNames = 'BASLIK'
        Properties.ListColumns = <
          item
            FieldName = 'BASLIK'
          end>
        Properties.ListSource = dsExcelBaslik
        Width = 80
      end
      object cxGrid1DBTableView1TRADING_GRP: TcxGridDBColumn
        Caption = 'Ticari '#304#351'lem Grubu'
        DataBinding.FieldName = 'TRADING_GRP'
        PropertiesClassName = 'TcxLookupComboBoxProperties'
        Properties.DropDownAutoSize = True
        Properties.DropDownListStyle = lsEditList
        Properties.KeyFieldNames = 'BASLIK'
        Properties.ListColumns = <
          item
            FieldName = 'BASLIK'
          end>
        Properties.ListSource = dsExcelBaslik
        Width = 80
      end
      object cxGrid1DBTableView1VAT_NR: TcxGridDBColumn
        Caption = 'Kdv No'
        DataBinding.FieldName = 'VAT_NR'
        PropertiesClassName = 'TcxLookupComboBoxProperties'
        Properties.DropDownAutoSize = True
        Properties.DropDownListStyle = lsEditList
        Properties.KeyFieldNames = 'BASLIK'
        Properties.ListColumns = <
          item
            FieldName = 'BASLIK'
          end>
        Properties.ListSource = dsExcelBaslik
        Width = 80
      end
      object cxGrid1DBTableView1INCHANGE: TcxGridDBColumn
        DataBinding.FieldName = 'INCHANGE'
        PropertiesClassName = 'TcxLookupComboBoxProperties'
        Properties.DropDownAutoSize = True
        Properties.DropDownListStyle = lsEditList
        Properties.KeyFieldNames = 'BASLIK'
        Properties.ListColumns = <
          item
            FieldName = 'BASLIK'
          end>
        Properties.ListSource = dsExcelBaslik
        Width = 80
      end
    end
    object cxGrid1Level1: TcxGridLevel
      GridView = cxGrid1DBTableView1
    end
  end
  object Panel1: TPanel [1]
    Left = 0
    Top = 377
    Width = 733
    Height = 41
    Align = alBottom
    TabOrder = 1
    DesignSize = (
      733
      41)
    object btExcelImport: TBitBtn
      Left = 99
      Top = 6
      Width = 85
      Height = 28
      Caption = #214'rnek Excel'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'MS Sans Serif'
      Font.Style = [fsBold]
      ParentFont = False
      TabOrder = 0
      OnClick = btExcelImportClick
    end
    object btKapat: TBitBtn
      Left = 638
      Top = 6
      Width = 85
      Height = 28
      Anchors = [akTop, akRight]
      Caption = 'Kapat'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'MS Sans Serif'
      Font.Style = [fsBold]
      ParentFont = False
      TabOrder = 1
      OnClick = btKapatClick
    end
    object btKaydet: TBitBtn
      Left = 9
      Top = 6
      Width = 85
      Height = 28
      Caption = 'Kaydet'
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Height = -11
      Font.Name = 'MS Sans Serif'
      Font.Style = [fsBold]
      ParentFont = False
      TabOrder = 2
      OnClick = btKaydetClick
    end
  end
  inherited alKeyControl: TActionList
    Left = 731
    Top = 166
  end
  inherited XPManifest: TXPManifest
    Left = 736
    Top = 216
  end
  object aqSablonList: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    BeforePost = aqSablonListBeforePost
    Parameters = <>
    SQL.Strings = (
      'Select * from TblUnitySevkAdresSablon')
    Left = 165
    Top = 123
  end
  object dsSablonList: TDataSource
    DataSet = aqSablonList
    Left = 231
    Top = 122
  end
  object cnnnExcel: TADOConnection
    LoginPrompt = False
    Left = 36
    Top = 103
  end
  object adoExcel: TADOQuery
    Connection = cnnnExcel
    LockType = ltBatchOptimistic
    Parameters = <
      item
        Name = 'serinos'
        DataType = ftString
        NumericScale = 255
        Precision = 255
        Size = 50
        Value = Null
      end>
    SQL.Strings = (
      'select bilisnocik,makinano from fatharhar '
      'where serinos=:serinos')
    Left = 36
    Top = 159
  end
  object dsExcel: TDataSource
    DataSet = adoExcel
    Left = 36
    Top = 215
  end
  object OpenExcel: TOpenDialog
    DefaultExt = '.xls'
    Filter = 'Excel Dosylar'#305'|*.xls'
    Left = 36
    Top = 271
  end
  object aqExcelBaslik: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'Select * from TblUnitySevkBaslikSablon where 1=2')
    Left = 162
    Top = 172
  end
  object dsExcelBaslik: TDataSource
    DataSet = aqExcelBaslik
    Left = 160
    Top = 220
  end
  object aqCariList: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    Parameters = <>
    SQL.Strings = (
      
        'select carikod,carikodu,FirmaAdi +'#39' - '#39'+Carikodu Firma  from car' +
        'i where Aktif='#39'A'#39' and unitycarikod is not null order by FirmaAdi' +
        ' +'#39' - '#39'+Carikodu')
    Left = 160
    Top = 271
  end
  object dsCariList: TDataSource
    DataSet = aqCariList
    Left = 226
    Top = 270
  end
end
